<html>

<head>

<title>WebUtil Version 1.0.5 - Production Release  Notes</title>



<link href="forms9i.css" rel="stylesheet" type="text/css">
</head>

<body>

<h1>WebUtil Version 1.0.5 - Production Release Notes</h1>
<p>August 2004 </p>
<p>Welcome to Oracle Forms WebUtil. This document contains the following sections:</p>
<ul>
  <li><a href="#introduction">Introduction</a></li>
  <li><a href="#Support">Support</a></li>
  <li><a href="#BugFixesinThisRelease">Bug Fixes in This Release</a> </li>
  <li><a href="#InstallingWebUtil">Installing WebUtil</a></li>
  <li><a href="#AdditionalWebUtilInstallationSteps">Additional WebUtil Installation Steps</a></li>
  <li><a href="#KnownIssues">Known Issues</a> </li>
</ul>
<h2><a name="introduction"></a>Introduction</h2>
<p>WebUtil is a pre-packaged set of components which provide client-server type functionality in
  Web-deployed Oracle Forms applications. WebUtil allows Forms developers to selectively execute code on the
  client machine rather than on the application server.
  WebUtil uses Pluggable Java Components to extend the Forms
  client, and PL/SQL to provide a simple  interface for using them. Therefore, no Java skill
is required to use WebUtil.</p>
<h2><a name="Support"></a>Support</h2>
<p> Oracle Forms WebUtil is a fully supported
  component of Oracle Forms.&nbsp; Support issues can be raised through the usual <br>
  support channels. </p>
<h2><a name="BugFixesinThisRelease"></a>Bug Fixes in This Release </h2>
<p>The following is a list of bug fixes  after
the preview release of WebUtil 1.0.2 (Beta). Some bugs for this release may not be relevant to prior releases. </p>
<table border=1 cellspacing=0 cellpadding=0 width=543>
  <tr>
    <th><center>Bug#<o:p></o:p></center></th>
    <th>
    Bug Description<o:p></o:p></th>
  </tr>
  <tr>
    <td u1:num="">
    2838998<o:p></o:p></td>
    <td>
    WEBUTIL_C_API : ADD_PARAMETER or
    REBIND_PARAMETER does not need value for OUT only parameters.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    2956040<o:p></o:p></td>
    <td>
    Save File Dialog does not preserve
    the sample file name after clicking at the directory.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3053652&nbsp;&nbsp; <o:p></o:p></td>
    <td>File Dialog gives java exception
    when incorrect file filter format is used.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3082119&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Release memory after excel sheet
    is closed.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3102320<o:p></o:p></td>
    <td>
    Added
    webutiljpi.htm and webutilbase.htm<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3109202&nbsp;&nbsp; <o:p></o:p></td>
    <td>Spelling
      correction in webutil.pll for SEPARATE and WRITABLE<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3111098&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    IS_AS_WRITABLE returning FALSE
    even though the directory is writable<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3151674&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Webutil File Transfer and Webutil,
    file cannot be deleted after transfer, sharing violation<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3163024&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    DOS format webutil.cfg with CRLF
    for newline is not read properly on UNIX.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3182601&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Listing root directories (i.e.
    drives in windows) does not work after listing the files in a directory.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3191693&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    CLIENT_IMAGE.READ_IMAGE_FILE
    displays wrong filename if invalid filename is used<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3216372&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Get WUC-18 download error when
    using jinitiator 1.3.1.13. URL is not properly constructed when the install
    location is relative.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">3226966&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    File Filter in webutil does not
    work with leading characters, like t*.fmb<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3289034&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Uploading bigger files, say about
    16MB or more, fails<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="3163024">
    3309086<o:p></o:p></td>
    <td>
    Webutil_file_transfer : change in
    comment only<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3311898<o:p></o:p></td>
    <td>
    When uploading a file from Client
    to Apps Server using the function&nbsp; <br>
  &quot;webutil_file_transfer.Client_To_AS_with_progress&quot;, if the folder given
    in the Server machine does not exists, proper, proper error is raised. The
    error looks like &#8220;WUT-132:Invalid Application Server file name. Cannot create
    application server file&quot; appended with the AS file name and the java
    exception.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3312115<o:p></o:p></td>
    <td>
    Hanging browser: When downloading
    a file from database to Client, if the sepecified folder does not exists in
    the client, proper error is raised and browser does not hang.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="">
    3315016<o:p></o:p></td>
    <td>
    Only a change in comment spelling
    for Get_Work_Area.<o:p></o:p></td>
  </tr>
  <tr>
    <td u1:num="2956040">
    3363404&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    When wrong item name is given to
    READ_IMAGE_FILE, it should throw an error<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3454831&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Client to AS file upload copies
    zero sized file when client filename contains +<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3457083<o:p></o:p></td>
    <td>
    When transfering a file from
    client to Server, if the client file does not exists or it is a invalid file
    name, proper error is raised.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3463742<o:p></o:p></td>
    <td>
    Error message corrected if the
    directory for directory listing is not valid.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3466375<o:p></o:p></td>
    <td>
    Spelling correction for comments
    in WEBUTIL_SEPARATEFRAME<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3494408<o:p></o:p></td>
    <td>
    Corrected mixing of semicolon and
    colon in Webutil.env classpath.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3494419<o:p></o:p></td>
    <td>
    Typo in Webutil.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3494430<o:p></o:p></td>
    <td>
    CLIENT_TEXT_IO can read or write
    if the file is opened in APPEND mode.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3494473<o:p></o:p></td>
    <td>
    Calling
    URL_To_Client_With_Progress, file size parameter is made optional to match
    with URL_To_Client.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3494500<o:p></o:p></td>
    <td>
    Typo error message in WUF-201<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3496667&nbsp;&nbsp; <o:p></o:p></td>
    <td>
    Handle incorrect file names passes
    as parameter to file transfer function and show proper error messages.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3497366<o:p></o:p></td>
    <td>
    Forms debugger should work with
    webutil<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3535930<o:p></o:p></td>
    <td>
    Client_Image.Write_image_file:
    If there is no image in the Image item, no file will be created on the client
    side and no error will be returned. This is how WRITE_IMAGE_FILE of client server forms behaves.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3535953<o:p></o:p></td>
    <td>    Client_Image.Write_image_file: If
    the file name entered contains any invalid <br>
    character like
    /\:*?''&lt;&gt;| proper error message is displayed.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3535968<o:p></o:p></td>
    <td>
    Raise proper error if client file
    name contains some invalid character like &lt;&gt;?<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3535988<o:p></o:p></td>
    <td>
    file transfer:url-client:if url is
    null, appropriate error &#8220;WUC-025: URL cannot be null&#8221; is raised now.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3536059<o:p></o:p></td>
    <td>
    Invalid characters on console
    while calling CLIENT_TOOL_ENV.GETVAR are corrected.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3542318<o:p></o:p></td>
    <td>
    On solaris and unix, while the
    security warning dialog for the webutil.jar certificate trust pops up, jvm
    hangs. This is now fixed.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3547792<o:p></o:p></td>
    <td>
    Regression bug introduced in
    1.0.4. Transfer from database to client not working<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3575129<o:p></o:p></td>
    <td>
    About Webutil info will have
    production bean versions instead of beta.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3575230<o:p></o:p></td>
    <td>
    Regression-1.0.4 : Auto-download
    not working.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3578082<o:p></o:p></td>
    <td>
    URL_TO_CLIENT_WITH_PROGRESS throws
    IllegalArgumentException error in java console.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3578105<o:p></o:p></td>
    <td>
    Failure in transfer from URL to
    Client causes immediate successive call to any other valid transfer like DB
    to client etc.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3578127<o:p></o:p></td>
    <td>
    WebUtil_File.COPY should not allow
    copying the same source to the same target.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3578133<o:p></o:p></td>
    <td>
    Transfer empty files from client
    to DB or AS should not be allowed.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3684467<o:p></o:p></td>
    <td>
    Download or autodownload errors in
    SunOS and linux fixed.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3684497<o:p></o:p></td>
    <td>
    Java home properly set in linux /
    SunOS for auto-download.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3686914<o:p></o:p></td>
    <td>
    User libraries in auto-download missing
    from Webutil.properties.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3719741<o:p></o:p></td>
    <td>
    Corrected spelling &#8220;Loading
    Webutil&#8230;&#8221; to &#8220;Loading WebUtil&#8230;&#8221;<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3723646<o:p></o:p></td>
    <td>
    Cleaned up unwanted comment for
    CLIENT_WIN_API_ENVIRONMENT getting default printer since it is not
    implemented.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3723649<o:p></o:p></td>
    <td>
    java.lang.UnsatisfiedLinkError
    during loading library is handled so that forms does not stop working<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3729301<o:p></o:p></td>
    <td>
    WebUtil_File.File_Copy should not
    throw unhandled FileNotFoundException when the file is invalid or contains
    invalid parent directory path etc.<o:p></o:p></td>
  </tr>
  <tr>
    <td>
    3729320<o:p></o:p></td>
    <td>
    WebUtil_SeparateFrame.setIcon will
    not set a blank icon when the icon image path is invalid or unable to load.
    Instead it will retain the current icon and throw error-603: &#8220;Unable to load
    icon image &lt;absolute_image_path&gt;&#8221;.<o:p></o:p></td>
  </tr>
</table>
<h2><a name="InstallingWebUtil"></a>Installing WebUtil </h2>
<p> WebUtil works in the client, middle,  and database tiers. The <em>WebUtil User's Guide</em>, which is shipped in the <span class="code_no_color">/doc</span> directory of this distribution, contains detailed information for installing and configuring WebUtil. Use the  handy checklist in Appendix A to guide you. <o:p></o:p></p>
<p><o:p>Before installing WebUtil, make sure you have the following:</o:p></p>
<ul>
  <li>An Internet connection</li>
  <li>An installation of Java 2 SDK, Standard Edition 1.3.1 (available from <a href="http://www.javasoft.com/">http://www.javasoft.com/</a>) or above.<o:p></o:p></li>
  <li>The JACOB libraries from    <a href="http://www.danadler.com/jacob/jacobBin_17.zip" target="_blank">http://www.danadler.com/jacob/jacobBin_17.zip</a> .  </li>
</ul>
<h2><a name="AdditionalWebUtilInstallationSteps"></a>Additional WebUtil Installation Steps</h2>
<p>Use this list  along with
the installation checklist in Appendix A of <em>WebUtil User's Guide</em>:</p>
<ol>
  <li>Download <a
  href="http://danadler.com/jacob/jacobBin_17.zip">http://danadler.com/jacob/jacobBin_17.zip</a>. This archive supplies the core OLE functionality provided by WebUtil.</li>
  <li>From the JACOB zip file, extract both  <span class="code_no_color">jacob.dll</span>  and jacob.jar into the WebUtil <span class="code_no_color">/lib</span> directory.</li>
  <li>You need to sign both the <span class="code_no_color">webutil.jar</span> and the <span class="code_no_color">jacob.jar</span> with the same digital certificate.    This is
    a one-time operation which allows your end-users to trust that the JACOB
    routines can access client side resources . If you do not have an existing signing certificate or are not sure how to go about signing jar files some scripts have been supplied in the <span class="code_no_color">/util</span> directory for you. <br>
    <br>
    <span class="StepIntro">To sign the Jar files :</span><br>
    <ol type="a">
      <li>In the WebUtil <span class="code_no_color">/util</span> directory, edit <span class="code_no_color">signer.properties</span> by changing the following values:
        <br>
        <ul>
          <li><span class="code_no_color">JDK_HOME</span> to the location of the root directory of your Java SDK installation </li>
          <li><span class="code_no_color">JINIT_HOME</span> to the location of your JIinitiator root directory </li>
          <li>The <span class="code_no_color">DN_*</span> settings to describe the distinguished name for the signer and your organization </li>
          <li>The password that protects the WebUtil certificate (if required )</li>
        </ul>
      </li>
      <li>Open a Command window and change to the WebUtil <span class="code_no_color">\util</span> directory. </li>
      <li>Issue <code>makecert</code>. <br>
        <strong>      Important:</strong> you only need to do this <em>once</em> to create the certificate that will be installed in the JInitiator Keystore<o:p></o:p></li>
      <li>Issue <code>sign c:\webutil\lib\webutil.jar</code> (or the path to where you installed WebUtil)<o:p></o:p></li>
      <li>Issue <code>c:\webutil\lib\jacob.jar <o:p></o:p></code><o:p></o:p><o:p></o:p></li>
    </ol>
  </li>
  <li>Because in this release the Jacob code is in an external Jar file and not incorporated into <span class="code_no_color">webutil.jar</span>,  it needs to be downloaded. To do this change the <span class="code_no_color">webUtilArchive</span> setting to read:
    <br>
    <br>
  <code>webUtilArchive=/forms90/webutil/webutil.jar,/forms90/webutil/jacob.jar</code><o:p></o:p></li>
</ol>
<h2><a name="KnownIssues"></a>Known Issues<o:p></o:p></h2>
<ol>
  <li>    Certification with  Sun's JRE 1.4.1_07 failed because of a known issue in the JACOB code. However, you can find a build which
  will work with JRE 1.4.1_07, from <a
href="http://groups.yahoo.com/group/jacob-project">http://groups.yahoo.com/group/jacob-project</a>.<o:p></o:p></li>
  <li>
    WebUtil
    does not work on certain versions of Linux due to known forms TEXT_IO issues.
  The workaround is to set the environment variable <span class="code_no_color">LD_ASSUME_KERNEL=2.4.19</span>.<o:p></o:p></li>
  <li>
    WebUtil
    downloads <span class="code_no_color">install.syslib</span> libraries mentioned in <span class="code_no_color">webutil.cfg</span> into the <span class="code_no_color">bin</span>  directory of the JRE or JVM. The client  needs write
  permission in that particular <span class="code_no_color">bin</span> directory.</li>
  <li>When using Oracle Forms Webutil File transfer function, you must take into
  consideration performance and resources issues.&nbsp; The current implementation
is that the size of the Forms application server process will increase in
correlation with the size of the file that is being transferred.&nbsp; This, of course, has
minimum impact with file sizes of 10s or 100's of KiloBytes.&nbsp; But transfers of
10s or 100s of Megabytes will impact the server side process.&nbsp; This is
currently tracked in bug 3151489.</li>
</ol>
<p><font size="-2">Copyright&nbsp;&copy;&nbsp;2004,&nbsp;Oracle.&nbsp;All&nbsp;rights&nbsp;reserved.</font> </p>
</body>

</html>
